﻿CREATE TABLE [dbo].[UserInfo] (
    [Id]           VARCHAR (32)  NOT NULL,
    [Name]         NVARCHAR (50) NOT NULL,
    [Number]       NVARCHAR (30) NOT NULL,
    [DepartmentId] VARCHAR (32)  NULL,
    [Sex]          NVARCHAR (3)  NOT NULL,
    [PositionId]   VARCHAR (32)  NULL,
    [Phone]        VARCHAR (32)  NULL,
    [BirthDay]     DATETIME      NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

